<?php
session_start() ;
require_once 'include/dbcon.php';
$regno = $_SESSION['rgno'] ;
$sql = $DBcon->prepare("select * from student where regno =:reg") ;
$sql->bindparam(":reg",$regno) ;
$sql->execute() ;
if($sql->rowcount() > 0)
{
$rowa = $sql->FETCH(PDO::FETCH_ASSOC) ;
$fname = $rowa['surname'] ;
$md = $rowa['middlename'] ;
$ln = $rowa['lastname'] ;
$studname = $fname.'&nbsp'.$md.'&nbsp'.$ln ;
$avat = $rowa['avatar'] ;
}

if(isset($_POST['first']))
{
$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['yr']);
$_SESSION["term"] = 'FIRST TERM' ;
$classid = $_SESSION["classid"] ;
//mysql_select_db("$database", $conn);
$schyear = $_SESSION["schsesion"] ;
$classid = $_SESSION["classid"] ;
$term = $_SESSION["term"] ;
//$level = substr($classid, 0, 7);
//$level1 = substr($classid, 0, 2);
//check pin validity

$sql1 = $DBcon->prepare("select * from pinassociate where PINCODE =:p") ;
$sql1->bindparam(':p', $pin) ;
$sql1->execute() ;
$rc = $sql1->rowcount() ;

if($rc > 0)
 
{
	
$row1 = $sql1->FETCH(PDO::FETCH_ASSOC) ;
 $pin = $row1['PINCODE'] ;
 $owner = $row1['REGNO'] ;
 $numbused = $row1['NOUSED'] ;
 $tm = $row1['TERM'] ;
 $yr = $row1['acadsession'] ;
   //check reg no
if($numbused >= 5) $msg[] = 'You have used this Pin above its Limit please buy another Card' ;
if($term != $tm)  $msg[] = 'You have used this Pin to Check another Term Result, Please Get another Card' ;
if($yr != $schyear) $msg[] = 'You have used this Pin to Check another Session Result, Please Get another Card' ;
  }// end if access, i.e, if pin exist
  if(empty($msg))
{

$sqlc = $DBcon->prepare(" select * from marks where (stregno =:rg and acad_session =:yr) and (term =:tm and stclass = :cs)") ;
$sqlc->bindparam(':rg', $regno) ;
$sqlc->bindparam(':yr', $schyear) ;
$sqlc->bindparam(':tm', $term) ;
$sqlc->bindparam(':cs', $classid) ;
$sqlc->execute() ;
$rcx = $sqlc->rowcount() ;
//$resultc = mysql_query($sqlc) or die('Error: ' . mysql_error());
if($rcx > 0) 
{
  $rowc = $sqlc->FETCH(PDO::FETCH_ASSOC) ;
  $resultnoc = $rowc['stregno'] ;
  $_SESSION["getresultc"] = $resultnoc ;
 }
else
$msg[] = 'Sorry, Your Result is not Ready or Make Sure you entered correct Information' ; 
}
 if(empty($msg))  header("location: resultsheet/basicsheet.php");
 	
}


if(isset($_POST['second']))
{
$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['yr']);
$_SESSION["term"] = 'SECOND TERM' ;
$classid = $_SESSION["classid"] ;
//mysql_select_db("$database", $conn);
$schyear = $_SESSION["schsesion"] ;
$classid = $_SESSION["classid"] ;
$term = $_SESSION["term"] ;
//$level = substr($classid, 0, 7);
//$level1 = substr($classid, 0, 2);
//check pin validity

$sql1 = $DBcon->prepare("select * from pinassociate where PINCODE =:p") ;
$sql1->bindparam(':p', $pin) ;
$sql1->execute() ;
$rc = $sql1->rowcount() ;

if($rc > 0)
 
{
	
$row1 = $sql1->FETCH(PDO::FETCH_ASSOC) ;
 $pin = $row1['PINCODE'] ;
 $owner = $row1['REGNO'] ;
 $numbused = $row1['NOUSED'] ;
 $tm = $row1['TERM'] ;
 $yr = $row1['acadsession'] ;
   //check reg no
if($numbused >= 5) $msg[] = 'You have used this Pin above its Limit please buy another Card' ;
if($term != $tm)  $msg[] = 'You have used this Pin to Check another Term Result, Please Get another Card' ;
if($yr != $schyear) $msg[] = 'You have used this Pin to Check another Session Result, Please Get another Card' ;
  }// end if access, i.e, if pin exist
  if(empty($msg))
{

$sqlc = $DBcon->prepare(" select * from marks where (stregno =:rg and acad_session =:yr) and (term =:tm and stclass = :cs)") ;
$sqlc->bindparam(':rg', $regno) ;
$sqlc->bindparam(':yr', $schyear) ;
$sqlc->bindparam(':tm', $term) ;
$sqlc->bindparam(':cs', $classid) ;
$sqlc->execute() ;
$rcx = $sqlc->rowcount() ;
//$resultc = mysql_query($sqlc) or die('Error: ' . mysql_error());
if($rcx > 0) 
{
  $rowc = $sqlc->FETCH(PDO::FETCH_ASSOC) ;
  $resultnoc = $rowc['stregno'] ;
  $_SESSION["getresultc"] = $resultnoc ;
 }
else

$msg[] = 'Sorry, Your Result is not Ready or Make Sure you entered correct Information' ; 
}
 if(empty($msg))  header("location: resultsheet/basicsheet.php");
 		
}
if(isset($_POST['third']))
{
$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['yr']);
$_SESSION["term"] = 'THIRD TERM' ;
$classid = $_SESSION["classid"] ;
//mysql_select_db("$database", $conn);
$schyear = $_SESSION["schsesion"] ;
$classid = $_SESSION["classid"] ;
$term = $_SESSION["term"] ;
//$level = substr($classid, 0, 7);
//$level1 = substr($classid, 0, 2);
//check pin validity

$sql1 = $DBcon->prepare("select * from pinassociate where PINCODE =:p") ;
$sql1->bindparam(':p', $pin) ;
$sql1->execute() ;
$rc = $sql1->rowcount() ;

if($rc > 0)
 
{
	
$row1 = $sql1->FETCH(PDO::FETCH_ASSOC) ;
 $pin = $row1['PINCODE'] ;
 $owner = $row1['REGNO'] ;
 $numbused = $row1['NOUSED'] ;
 $tm = $row1['TERM'] ;
 $yr = $row1['acadsession'] ;
   //check reg no
if($numbused >= 5) $msg[] = 'You have used this Pin above its Limit please buy another Card' ;
//if($term != $tm)  $msg[] = 'You have used this Pin to Check another Term Result, Please Get another Card' ;
if($yr != $schyear) $msg[] = 'You have used this Pin to Check another Session Result, Please Get another Card' ;
  }// end if access, i.e, if pin exist
  if(empty($msg))
{

$sqlc = $DBcon->prepare(" select * from marks where (stregno =:rg and acad_session =:yr) and (term =:tm and stclass = :cs)") ;
$sqlc->bindparam(':rg', $regno) ;
$sqlc->bindparam(':yr', $schyear) ;
$sqlc->bindparam(':tm', $term) ;
$sqlc->bindparam(':cs', $classid) ;
$sqlc->execute() ;
$rcx = $sqlc->rowcount() ;
//$resultc = mysql_query($sqlc) or die('Error: ' . mysql_error());
if($rcx > 0) 
{
  $rowc = $sqlc->FETCH(PDO::FETCH_ASSOC) ;
  $resultnoc = $rowc['stregno'] ;
  $_SESSION["getresultc"] = $resultnoc ;
 }
else
$msg[] = 'Sorry, Your Result is not Ready or Make Sure you entered correct Information' ; 
}
 if(empty($msg))  header("location: resultsheet/basicsheet.php");
 		
}

// check annual
if(isset($_POST['annual']))
{
	$msg = array() ;
$pin = $_SESSION['pin'] ;
$regno = $_SESSION['rgno'] ;
$_SESSION["schsesion"] = trim($_POST['yr']);
$_SESSION["term"] = 'ANNUAL TERM' ;
$classid = $_SESSION["classid"] ;
//mysql_select_db("$database", $conn);
$schyear = $_SESSION["schsesion"] ;
$classid = $_SESSION["classid"] ;
//$term = $_SESSION["term"] ;

$sqlc = $DBcon->prepare(" select * from marks where (stregno =:rg and acad_session =:yr) and (stclass = :cs )") ;
$sqlc->bindparam(':rg', $regno) ;
$sqlc->bindparam(':yr', $schyear) ;
//$sqlc->bindparam(':tm', $term) ;
$sqlc->bindparam(':cs', $classid) ;
$sqlc->execute() ;
$rcx = $sqlc->rowcount() ;
//$resultc = mysql_query($sqlc) or die('Error: ' . mysql_error());
if($rcx > 0) 
{
  $rowc = $sqlc->FETCH(PDO::FETCH_ASSOC) ;
  $resultnoc = $rowc['stregno'] ;
  $_SESSION["getresultcm"] = $resultnoc ;
 }
else
$msg[] = 'Sorry Your Result is not ready, check back next week' ;

//check pin
$sql1 = $DBcon->prepare("select * from pinassociate where PINCODE =:p") ;
$sql1->bindparam(':p', $pin) ;
$sql1->execute() ;
$rc = $sql1->rowcount() ;

if($rc > 0)
 
{
	
$row1 = $sql1->FETCH(PDO::FETCH_ASSOC) ;
 $pin = $row1['PINCODE'] ;
 $owner = $row1['REGNO'] ;
 $numbused = $row1['NOUSED'] ;
// $tm = $row1['TERM'] ;
 $yr = $row1['acadsession'] ;
   //check reg no
if($numbused >= 5) $msg[] = 'You have used this Pin above its Limit please buy another Card' ;
//if($term != $tm)  $msg[] = 'You have used this Pin to Check another Term Result, Please Get another Card' ;
if($yr != $schyear) $msg[] = 'You have used this Pin to Check another Session Result, Please Get another Card' ;
  }// end if access, i.e, if pin exist

if(empty($msg)) header("location: resultsheet/pjsheet.php");
	
}



?>
<!DOCTYPE html>
<html dir="ltr" lang="en-US"><head><!-- Created by Artisteer v4.3.0.60858 -->
    <meta charset="utf-8">
    <title>Home</title>
    <meta name="viewport" content="initial-scale = 1.0, maximum-scale = 1.0, user-scalable = no, width = device-width">

    <!--[if lt IE 9]><script src="https://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
    <link rel="stylesheet" href="style.css" media="screen">
    <!--[if lte IE 7]><link rel="stylesheet" href="style.ie7.css" media="screen" /><![endif]-->
    <link rel="stylesheet" href="style.responsive.css" media="all">
<link rel="stylesheet" type="text/css" href="http://fonts.googleapis.com/css?family=Crete+Round|Oswald|PT+Sans&amp;subset=latin">

    <script src="jquery.js"></script>
    <script src="script.js"></script>
    <script src="script.responsive.js"></script>



<style>.art-content .art-postcontent-0 .layout-item-0 { margin-top: 15px;margin-bottom: 0px;  }
.art-content .art-postcontent-0 .layout-item-1 { color: #706100;  }
.art-content .art-postcontent-0 .layout-item-2 { border-right-style:dotted;border-right-width:1px;border-right-color:#DBE1D0; color: #706100; padding-right: 15px;padding-left: 10px;  }
.art-content .art-postcontent-0 .layout-item-3 { border-right-style:dotted;border-right-width:1px;border-right-color:#DBE1D0; color: #706100; padding-right: 15px;padding-left: 15px;  }
.ie7 .art-post .art-layout-cell {border:none !important; padding:0 !important; }
.ie6 .art-post .art-layout-cell {border:none !important; padding:0 !important; }

</style></head>
<body>
<div id="art-main">
<?php include('header.php') ; ?>
<div class="art-sheet clearfix">
            <div class="art-layout-wrapper">
                <div class="art-content-layout">
                    <div class="art-content-layout-row">
                        <div class="art-layout-cell art-content">
                        <article class="art-post art-article">
                        <div class="art-postcontent art-postcontent-0 clearfix">
                        <div class="art-content-layout-row">
    <div class="art-layout-cell layout-item-2" style="width: 100%" >
    <fieldset ><legend ><h4>Instructions</h4></legend>
     <p style="text-align:justify; width:90%; margin-left:auto; margin-right:auto;">To view results, simply select the academic year of the result you want to view and click the corresponding button to the term you want to view, click Cumulative button to view annual results. note also that you can upload a good passport photograph and have your picture in every result you print. just click upload photograph button to start the process. follow the screen instruction to achieve this.<br/>
                Note: Always make sure that the Reg number and name display under student detail section are yours before printing your result. If not logout and Login with correct data to make sure you do print some one else result.</p>
    </fieldset>
		
		
    </div>
    </div>
                        <div class="art-content-layout">
    <div class="art-content-layout-row">
    <div class="art-layout-cell layout-item-2" style="width: 30%" >
    <h4 style="font-family:Baskerville, 'Palatino Linotype', Palatino, 'Century Schoolbook L', 'Times New Roman', serif;">Student Details</h4> 
 <p style="text-align:justify; font-size:18px">
  
       Your Name is:::<br/><?php if(isset($studname)) echo $studname ; ?><br/><br/>
        Your RegNo is:::<br/><br/><?php if(isset($regno)) echo $regno ; ?><br/>
        <?php //if(isset($gender)) echo $gender ; ?><br/>
       
   
          
        
        </p>
        
		</p>
    </div>
    <div class="art-layout-cell layout-item-2" style="width: 30%" >
          <center>
        <h4 style="font-family:Baskerville, 'Palatino Linotype', Palatino, 'Century Schoolbook L', 'Times New Roman', serif;">Profile Pix</h4> 
           </center>   
       <img src="images/no-avatar.jpg" width="150" height="150" /><br/><br/>
     <a href="">UPLOAD YOUR PICTURE</a>
        
      
    </div>
    
    <div class="art-layout-cell layout-item-2" style="width: 40%" >
         
        <h4 style="font-family:Baskerville, 'Palatino Linotype', Palatino, 'Century Schoolbook L', 'Times New Roman', serif;">Print Results</h4> 
              <div>        
       <?php
if (isset($msg)) {
  echo '<ul>';
  foreach ($msg as $item)
   {
    echo "<li>$item</li>";
	}
  echo '</ul>';
  }

?>
</div><br/>
      
        <form name="form"  method="post" action="" >
        Select Academic Year<br/>
          <select name="yr" required style="width:90%; height:40px;">
          <option> </option>
           <option>2015/2018 </option>
          <option>2016/2017</option>
        <option>2017/2018</option>
        <option>2018/2019</option>
        <option>2019/2020</option>
        <option>2020/2021</option>
        <option>2021/2022</option>
        <option>2022/2023</option>
        <option>2023/2024</option>
        <option>2024/2025</option>
           <option>2025/2026</option>
            <option>2026/2027</option>
             <option>2027/2028</option>
          </select><br/><br/>
          
          <input type="submit" name="first" style="width:90%" class="art-button"  value="FIRST TERM" /><br/><br/>
          
          <input type="submit" name="second" style="width:90%" class="art-button"  value="SECOND TERM" /><br/><br/>
          <input type="submit" name="third" style="width:90%" class="art-button"  value="THIRD TERM" /><br/><br/>
           <input type="submit" name="annual" style="width:90%" class="art-button"  value="CUMULATIVE" /><br/><br/>
          </form>
        
        
    </div>
    </div>
    
    
</div>


                        
                        
                        
                        
                        
                        
                        </div>
                        
                        
                        </article>
                        </div>
                         <?php //include('sidec.php') ; ?>
                        </div>
                        </div>
                        </div>
                        </div>

<?php include('footer.php') ; ?>
</div>
</body>
</html>